Release 10.1A: OpenEdge Data Management:
SQL Development

Data Control Language and Security

The SQL Data Control Language (DCL) provides security for your database. The DCL consists of the GRANT, REVOKE, COMMIT, and ROLLBACK statements. GRANT and REVOKE statements enable you to determine whether a user can view, modify, add, or delete database information.

This chapter covers the GRANT and REVOKE statements. COMMIT and ROLLBACK are covered in Chapter 8, " Data Control Language and Transaction Behavior."

This chapter contains the following sections:

Working with database security
Creating users
Granting privileges
Verifying privileges
Revoking privileges
Note: This chapter gives an overview of DCL statements. For complete syntax of each statement, see OpenEdge Data Management: SQL Reference .